#!/usr/bin/env python
# $Id: test2-8.py df54dec975f4 2012/09/09 20:22:40 pgurumur $
# Copyright (c) 2012 Prabhu Gurumurthy <pgurumur@gmail.com>
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
# WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
# ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
# WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
# ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
#

__version__  = "$Revision: df54dec975f4 $"
__author__   = "$Author: pgurumur $"
__modified__ = "$Date: 2012-09-09 20:22:40Z $"

from venya.lib import sql
from venya.lib import ip

db = sql.mysql("netdot", "andromeda", "neteng", "Ms0B9GBWQ2fJ2di")
tables = db.inspect()
devtable = None
iptable = None
for ix in tables:
   if ix == "device":
      devtable = ix
   elif ix == "ipblock":
      iptable = ix

print dir(devtable.table)
# print devtable.query.all()
for target in devtable.query.values(devtable.table.c.snmp_target):
   addr, version = iptable.query.filter(
         iptable.table.c.id == target[0]).values(
         iptable.table.c.address, iptable.table.c.version).next()
   try:
      print ip.ip(int(addr), version = version)
   except ip.IPError, message:
      print message
